<%@include file="connection.jsp" %>
        
            <%
                String id=request.getParameter("id");
                st=con.createStatement();
                rs=st.executeQuery("SELECT * from pf_detail where sr_no="+id);
                String nm=null,qty=null,price=null,date=null,pf_id=null;
                while(rs.next()){
                    nm=rs.getString("com_id");
                    qty=rs.getString("buy_qty");
                    price=rs.getString("buy_price");
                    date=rs.getString("date");
                    pf_id=rs.getString("pf_id");
                }
                rs=st.executeQuery("select ticker from company where com_id="+nm);
                while(rs.next()){
                    nm=rs.getString("ticker");
                }
               
                out.print("{\"ticker\":\""+nm+"\",\"qty\":\""+qty+"\",\"price\":\""+price+"\",\"date\":\""+date+"\"}");
            %>
           